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 |