<taPAEquipLogLineInsert>
Element name |
Data type |
Length |
Required |
Default |
Description |
|
---|---|---|---|---|---|---|
PAEQLTRX | i4 | 2 | Y | Not applicable | PA Equipment Transaction Type 1=Standard 2=Referenced | |
PAEQLOGNO | string | 17 | Y | Not applicable | PA Equipment Document Number | |
PADOCDT | datetime | 8 bytes (19 to 23 chars) | Y | Not applicable | PA Document Date | |
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 | |
LNITMSEQ | i4 | 4 | N | 0 | Line Item Sequence | |
PADT | datetime | 8 bytes (19 to 23 chars) | Y | Not applicable | PA Date | |
PAPROJNUMBER | string | 15 | Y | Not applicable | Project ID | |
PACOSTCATID | string | 15 | Y | Not applicable | Cost Category ID | |
PATB | datetime | 8 bytes (19 to 23 chars) | N | <blank> | PA Time Begin | |
PATE | datetime | 8 bytes (19 to 23 chars) | N | <blank> | PA Time End | |
PAQtyQ | number | 21 | N | 0 | PA Quantity | |
PAbllngtype | i4 | 2 | N | 1 | PA Billing Type 1=STD, 2=N/C, 3=N/B | |
PAUnit_of_Measure | string | 9 | N | <blank> | PA Unit of Measure | |
PAUNITCOST | number | 21 | N | 0 | PA Unit Cost | |
PATOTCST | number | 21 | N | 0 | PA Total Cost | |
PAtx500 | string | 256 | N | <blank> | PA Billing Note Text | |
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.