| field name | data type | mnd. | description |
|---|---|---|---|
| pli_keyid | integer | yes | Key ID |
| pli__qadc03 | character(80) | no | |
| pli__qadc04 | character(80) | no | |
| pli_supplier | character(80) | no | Supplier |
| pli_invoice | character(30) | no | Invoice Number |
| pli_invoice_amt | decimal(10) | no | Invoice Amount |
| pli_curr | character(30) | no | Currency |
| pli_invoice_date | date | no | Invoice Date |
| pli_vo_ref | character(80) | no | Voucher |
| pli_ex_rate | decimal(10) | no | Exch Rate |
| pli_ex_rate2 | decimal(10) | no | Exch Rate 2 |
| pli_ex_ratetype | character(80) | no | Rate Type |
| pli_exru_seq | integer | no | Sequence |
| pli_taxable | logical | no | Taxable |
| pli_taxc | character(30) | no | Tax Class |
| pli_tax_env | character(30) | no | Tax Environment |
| pli_tax_in | logical | no | Tax In |
| pli_tax_usage | character(80) | no | Tax Usage |
| pli_tax_date | date | no | Tax Date |
| pli_mod_date | date | no | Modified Date |
| pli_mod_userid | character(80) | no | User ID |
| pli_user1 | character(80) | no | User Field Character 1 |
| pli_user2 | character(80) | no | User Field Character 2 |
| pli__qadc01 | character(80) | no | |
| pli__qadc02 | character(80) | no | |
| pli_domain | character(8) | yes | Domain |
| oid_pli_mstr | decimal(10) | no | |
| pli_fix_rate | logical | no | Fixed Rate |
| pli_cinvoice_id | integer | no | Invoice ID |
| pli_volume | decimal(10) | no | Volume |
| pli_vol_um | character(4) | no | Volume UM |
| pli_docmodel | character(3) | no | Document Model |
| pli_goodsamt | decimal(10) | no | Goods Amount |
| pli_traileramt | decimal(10) | no | Trailer Amount |
| pli_discamt | decimal(10) | no | Discount Amount |
| pli_ldamt | decimal(10) | no | Legal Doc Amount |
| pli_totwgt | decimal(10) | no | Total Weight |
| pli_wt_um | character(30) | no | Weight UM |
| pli_cr_terms | character(8) | no | Credit Terms |
| pli_shipperid | character(80) | no | Shipper ID |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| plid_pli_keyid | integer | yes | Invoice Key ID |
| plid_line | integer | yes | Line |
| plid_order_type | character(30) | no | Order Type |
| plid_order | character(80) | no | Order |
| plid_order_line | integer | no | Order Line |
| plid_inv_qty | decimal(10) | no | Invoice Quantity |
| plid_inv_cost | decimal(10) | no | Invoice Cost |
| plid_pvo_id | integer | no | Pending Voucher ID |
| plid_taxable | logical | no | Taxable |
| plid_taxc | character(30) | no | Tax Class |
| plid_tax_env | character(30) | no | Tax Environment |
| plid_tax_in | logical | no | Tax In |
| plid_tax_usage | character(80) | no | Tax Usage |
| plid_mod_date | date | no | Modified Date |
| plid_mod_userid | character(80) | no | User ID |
| plid_user1 | character(80) | no | User Field Character 1 |
| plid_user2 | character(80) | no | User Field Character 2 |
| plid__qadc01 | character(80) | no | |
| plid__qadc02 | character(80) | no | |
| plid_domain | character(8) | yes | Domain |
| oid_plid_det | decimal(10) | no | |
| plid_abs_id | character(80) | no | Shipper ID |
| plid_netwgt | decimal(10) | no | Net Weight |
| plid_grosswgt | decimal(10) | no | Gross Weight |
| plid_cmtindx | integer | no | Comment Index |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tpli_mstr.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |