PeopleSoft 9 Account Payables |
Table Name | LC_HDR |
Table Description |
LC_HDR |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | VARCHAR(5) | Yes | No |
LC_ID | VARCHAR(12) | Yes | No |
LC_TYPE | VARCHAR(4) | No | No |
IMPORT_EXPORT_IND | VARCHAR(1) | No | No |
AMOUNT | decimal(26,3) | No | No |
NET_AMOUNT | decimal(26,3) | No | No |
CURRENCY_CD | VARCHAR(3) | No | No |
BUS_UNIT_ON_BEHALF | VARCHAR(5) | No | No |
BUSINESS_UNIT_AP | VARCHAR(5) | No | No |
BUSINESS_UNIT_OM | VARCHAR(5) | No | No |
APPLICANT_LC | VARCHAR(15) | No | No |
APPLICANT_LC_BANK | VARCHAR(5) | No | No |
LC_NUMBER | VARCHAR(20) | No | No |
LC_AMEND_NBR | VARCHAR(10) | No | No |
FCLTY_ID | VARCHAR(12) | No | No |
VENDOR_SETID | VARCHAR(5) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
VNDR_LOC | VARCHAR(10) | No | No |
BANK_ACCT_SEQ_NBR | SMALLINT | No | No |
BANK_CD | VARCHAR(5) | No | No |
ISSUE_DT | PSDATE | No | No |
LC_AMEND_DT | PSDATE | No | No |
EXPIRATION_DT | PSDATE | No | No |
LAST_SHIPMENT_DT | PSDATE | No | No |
AIRSHIPMENT | VARCHAR(1) | No | No |
CONTAINER_SHIPMENT | VARCHAR(1) | No | No |
CREDIT_CONFIRMED | VARCHAR(1) | No | No |
CUSTOMER_PO | VARCHAR(25) | No | No |
DESCR150_MIXED | VARCHAR(150) | No | No |
DESCR254_MIXED | VARCHAR(254) | No | No |
EXTENDABLE | VARCHAR(1) | No | No |
TRANSHIPMENT | VARCHAR(1) | No | No |
REVOKABLE_IND | VARCHAR(1) | No | No |
LC_ADVISE_BY | VARCHAR(1) | No | No |
ORDER_NO | VARCHAR(10) | No | No |
PO_ID | VARCHAR(10) | No | No |
PARTIAL_SHIPMENT | VARCHAR(1) | No | No |
PCT_GOODS | decimal(5,2) | No | No |
PCT_LC | decimal(5,2) | No | No |
ORIG_OPRID | VARCHAR(30) | No | No |
ORIG_DTTM | PSDATETIME | No | No |
LAST_MAINT_OPRID | VARCHAR(30) | No | No |
LAST_MAINT_DTTM | PSDATETIME | No | No |
TRANSACTION_DT | PSDATE | No | No |
TRANSACTION_DTTM | PSDATETIME | No | No |
Index |
Name | Type | Unique | Member |
PS_LC_HDR | PK | Yes |
![]() |
PS1LC_HDR | IE10 | No |
![]() |
PS0LC_HDR | IE9 | No |
![]() |
Member(s) of "PS_LC_HDR" Index |
BUSINESS_UNIT |
LC_ID |
Member(s) of "PS1LC_HDR" Index |
LC_AMEND_NBR |
BUSINESS_UNIT |
LC_ID |
Member(s) of "PS0LC_HDR" Index |
LC_NUMBER |
BUSINESS_UNIT |
LC_ID |
Published June 06, 2007 |