<taPAEquipLogHdrInsert>
|
Element name |
Data type |
Length |
Required |
Default |
Description |
|
|---|---|---|---|---|---|---|
PAEQLTRX | i4 | 2 | Y | Not applicable | PA Equipment Log Transaction Type 1=Standard 2=Referenced | |
PAEQLOGNO | string | 17 | Y | Not applicable | PA Equipment Log Document Number | |
PADOCDT | datetime | 8 bytes (19 to 23 chars) | Y | Not applicable | PA Document Date | |
BACHNUMB | string | 15 | Y | Not applicable | Batch Number | |
PAEQUIPTID | string | 15 | Y | Not applicable | PA Equipment ID | |
PAREPD | i4 | 4 | Y | Not applicable | PA Reporting Period | |
PAREPDT | datetime | 8 bytes (19 to 23 chars) | Y | Not applicable | PA Reporting Period Begin Date | |
CURNCYID | string | 15 | Y | Not applicable | Currency ID | |
PAREFNO | string | 17 | N | <blank> | PA Reference Document Number | |
PAreptsuff | string | 5 | N | <blank> | PA Reporting Suffix - used to create a unique record if a record already exists with this PAEQUIPTID,PAREPD combination. | |
PACOMM | string | 51 | N | <blank> | PA Comment | |
PATQTY | number | 21 | N | 0 | PA Total Quantity | |
PAtotcosts | number | 21 | N | 0 | PA Total Costs | |
PATACRV | number | 21 | N | 0 | PA Total Accrued Revenues | |
XCHGRATE | number | 21 | N | 0 | Exchange Rate | |
RATETPID | string | 15 | N | <blank> | Rate Type ID | |
EXPNDATE | datetime | 8 bytes (19 to 23 chars) | N | <blank> | Expiration Date | |
EXCHDATE | datetime | 8 bytes (19 to 23 chars) | N | <blank> | Exchange Date | |
EXGTBDSC | string | 30 | N | <blank> | Exchange ID Desc. | |
EXTBLSRC | string | 50 | N | <blank> | Exchange Rate Source | |
RATEEXPR | i4 | 2 | N | <blank> | Rate Expiration The breakdown is: 1=Daily, 2=Weekly, 3=Bi-Weekly, 4=Semi-Monthly, 5=Monthly, 6=Quarterly, 7=Annually, 8=Miscellaneous, 9=None, 0=None | |
DYSTINCR | i4 | 2 | N | <blank> | Days to Increment Only used when RATEEXPR = 8 | |
RATEVARC | number | 21 | N | 0 | Rate Variance | |
TRXDTDEF | i4 | 2 | N | 0 | Trx Date Default 0=Exact Date, 1=Next Date, 2=Previous Date | |
RTCLCMTD | i4 | 2 | N | <blank> | Rate Calc. Method 0=Multiply, 1= Divide | |
PRVDSLMT | i4 | 2 | N | 0 | Previous Days Limits | |
DATELMTS | i4 | 2 | N | 0 | Date Limits 0=Unlimited, 1=Limited | |
TIME1 | datetime | 8 bytes (19 to 23 chars) | N | <blank> | Time 1 | |
RequesterTrx | i4 | 2 | N | 0 | Requester Transaction 0=false, 1=true - if true than populates Requester shadow table | |
USRDEFND1 | string | 50 | N | <blank> | User-defined field--developer use only | |
USRDEFND2 | string | 50 | N | <blank> | User-defined field--developer use only | |
USRDEFND3 | string | 50 | N | <blank> | User-defined field--developer use only | |
USRDEFND4 | string | 8000 | N | <blank> | User-defined field--developer use only | |
USRDEFND5 | string | 8000 | N | <blank> | User-defined field--developer use only | |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.